query for regular expression.

[busybeeitsme]

for example if mysql database contains 'ABCDE' as user id..

if the user gives search keyword as ' AB* ' or ' *DE' or 'AB*DE', the above record has to be retrieved.. how to write query for this??

thanks in advance

[Atli]

Hi.

Check out 11.4.2. Regular Expressions in the manual.