How to implement LIKE Clause in Query?

[saadkhan]

I want to find a certain string pattern from database and u`v used the following query for that:
SELECT * FROM myTable
WHERE name LIKE 'a%'

But i want to search a pattern which is been given by the user a the same time. Can there be a variable there with LIKE?

[Pilgrim333]

I want to find a certain string pattern from database and u`v used the following query for that:
SELECT * FROM myTable
WHERE name LIKE 'a%'

But i want to search a pattern which is been given by the user a the same time. Can there be a variable there with LIKE?

Hi,

If you are just submitting the query, then you can use the follwing:

 select * from myTable where name like '&p%

This will ask for user input.

Pilgrim

[debasisdas]

you can also use regular expression.