如何从php表单动态搜索mysql数据库

Question

I've a table on php form with search|---------|textfield connected to mysql database. What I want- If I entered some of text in search textfield it will show me records that contain this text automatically and when I click on that it will be selected. e.g-In patient table

name='Vilas Galave',
name='Ashok Galave'

And I entered search |Galave| it will show

'Vilas Galave'

'Ashok Galave'

Answer 1

You should checkout the string comparison functions in mysql. For example you could use a query like this to display all rows that contains the text Ashok:

SELECT * FROM <table> WHERE name LIKE '%Ashok%'