mankis
asked on
find words LIKE "some letters" query MySql
I have in MySql database for example this terms:
1. Techniker
2. Bautechniker
3. Weintechnologe
I need query that will display all results that contain letters that user types.
For example if someone types letter "t" it should give all results that have letter t anywhere in the word. That means all three results given above as example.
If someone types letters "te" or "tec" or "tech" or "techn" it should give all three results above given as example.
If someone types letters "techni" it should give results 1 and 2.
If someone types letters "techno" it should give result 3. etc.
Thank you for any help
1. Techniker
2. Bautechniker
3. Weintechnologe
I need query that will display all results that contain letters that user types.
For example if someone types letter "t" it should give all results that have letter t anywhere in the word. That means all three results given above as example.
If someone types letters "te" or "tec" or "tech" or "techn" it should give all three results above given as example.
If someone types letters "techni" it should give results 1 and 2.
If someone types letters "techno" it should give result 3. etc.
Thank you for any help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER