get all result that contains string "abc"

[isaac_cm]

newbie question ,
what is the select syntax to get all result that contains string "abc" other than using "like"

thanks

[btherl]

There are plenty of other ways, such as regular expressions.  Why don't you want to use like?

[isaac_cm]

I talk to myself and and said it must be other ways to do the same thing without using like so it is just for learning other ways :)

[mjlogan]

You could index the table and use the fulltext search for example.

[isaac_cm]

I need SQL SYNTAX

[Zane]

[code]SELECT * FROM table WHERE name REGEXP 'abc'[/code]

[isaac_cm]

that will do thanks