Devam Ediyor

488370 mysql regex problem

Hello,

I need some help from expert regex programmer, i am running the following query in a mysql UTF8 db, thinking it will not return the keyword with special characters like (&%*&^&%$^#$%^&*()) AND unknown character �, but this query seems to be failing... (see attached screenshot for the results...

anyone has any idea ?

------------------------------------------------------

SELECT * FROM `terms` WHERE CHAR_LENGTH(keyword) > 4 AND keyword NOT RLIKE '.*([-0-9a-z_]).*' AND keyword NOT RLIKE ' (.*)? \� (.*)? | (.*)? \( (.*)? | (.*)? \) (.*)? | (.*)? \% (.*)? | (.*)? \_ (.*)? | (.*)? \ (.*)? | (.*)? \{ (.*)? | (.*)? \} (.*)? | (.*)? \� (.*)? | (.*)? \; (.*)? | (.*)? \: (.*)? | (.*)? \! (.*)? | (.*)? \` (.*)? | (.*)? \# (.*)? | (.*)? $ (.*)? | (.*)? \% (.*)? | (.*)? \^ (.*)? | (.*)? \& (.*)? | (.*)? \* (.*)?| (.*)? \- (.*)? | (.*)? \+ (.*)? | (.*)? \= (.*)? | (.*)? \[ (.*)? | (.*)? \] (.*)? | (.*)? \| (.*)? | (.*)? " (.*)? | (.*)? \' (.*)? | (.*)? \, (.*)? | (.*)? \. (.*)? | (.*)? \? (.*)? | (.*)? \/ (.*)? | (.*)? \_ (.*)? | (.*)? " (.*)? | (.*)? \ (.*)? | ' AND keyword NOT RLIKE '(.*)[\a]|[a-z]|[\Â]|[\â](.*)' AND total > 30 AND total < 10000 AND keyword NOT LIKE '%�%' GROUP BY keyword ORDER BY date DESC;

-----------------------------------------------------------------

Beceriler: Her şey Kabul, C Programlama, MySQL, PHP

Daha fazlasını görün: regex c, programming terms, programming regex, regex, php regex, c regex, problem regex php, mysql characters, mysql running, regex php, character problem, regex expert, php 10000, php special characters, character programmer, mysql special character, special characters programming, utf8, special character problem php, programming screenshot, programmer character, php problem characters, order character php, mysql select, keyword mysql

İşveren Hakkında:
( 63 değerlendirme ) Sydney, Australia

Proje NO: #2234281