PHP & MySQL - preg_match and query

Question

i have rows of text like this in database:

row1 -> text text!? sometext..!
row2 -> text!! sometext !whatever
row3 -> sometext !
row4 -> !this is sometext sometext

just like preg_match, what is query to call rows that contains !(word) and !!

the result i want is like:

text!! sometext !whatever
!this is sometext sometext

anyone can help?

thank you very much!

your second result does not contain !! .. so should your row contain !sometext AND !! or only one of it? — rauschen
– rauschen, Commented Jan 20, 2012 at 15:15
hello, it could means !hello or !whatever, any text after ! (with no spacing) — KaLv1n K
– KaLv1n K, Commented Jan 20, 2012 at 15:24

Marc B · Accepted Answer · 2012-01-20 15:13:36Z

7

SELECT yourfield
FROM yourtable
WHERE yourfield REGEXP '(!!|!sometext)'

relevant docs here: http://dev.mysql.com/doc/refman/5.1/en/regexp.html

answered Jan 20, 2012 at 15:13

Marc B

362k44 gold badges433 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

KaLv1n K Over a year ago

hello Marc, thank you for your answer.. but "sometext" is not just "sometext", it could means !hello or !whatever, any text after ! (with no spacing) ?

Collectives™ on Stack Overflow

PHP & MySQL - preg_match and query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related