Solved

find words LIKE "some letters" query MySql

Posted on 2013-02-07
2
377 Views
Last Modified: 2013-02-07
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
0
Comment
Question by:mankis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
esolve earned 500 total points
ID: 38864312
SELECT * FROM Table WHERE Column LIKE '%SearchPhrase%'

or

DECLARE @Param VARCHAR(50)
SET @Param = '%te%'

SELECT * FROM Table WHERE Column LIKE @Param

or

SELECT t1.Notes,
       t2.Name
  FROM Table1 t1
  JOIN Table2 t2 ON t1.Notes LIKE CONCAT('%', t2.Name ,'%')

or

http://www.mysqltutorial.org/sql-like-mysql.aspx
0
 

Author Comment

by:mankis
ID: 38864371
I just realized I asked wrong question but your solution is correct for what I asked so I will close question and give you the points. Thank you.
0

Featured Post

Upcoming Webinar: Securing your MySQL/MariaDB data

Join Percona’s Chief Evangelist, Colin Charles as he presents Securing your MySQL®/MariaDB® data on Tuesday, July 11, 2017 at 7:00 am PDT / 10:00 am EDT (UTC-7).

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question