Like keyword

rajesh_css · June 25th, 2009, 03:27 AM

Hi,

is there any other way to do the below query

select key,value from dual where key like('A%','B%[%]')

i mean to say like as we cannot use two or more strings for a like function how can we write a select statement to search in two strings using wild card characters.

Thanks in Advance

Raj

iamrakesh22 · June 25th, 2009, 06:17 AM

If you are using MySQL you try MATCH() function, check the following link
http://dev.mysql.com/doc/refman/5.1/...xt-search.html

rajesh_css · June 25th, 2009, 08:13 AM

thanks ...

i am using oracle 10g