Questions tagged as 'operador-like'

3
answers

What is the difference between Full Text Search and LIKE?

I've heard a lot about Full Text Search (FTS) lately, and they told me that I should use this instead of writing queries with LIKE . But how to use Full Text Search ? What are the advantages and disadvantages? And when is it really better...
asked by 21.03.2017 / 16:51
2
answers

LIKE query performance in MySQL

Is there any way to increase the performance of a query with LIKE '%string%' in MySQL? I know that if LIKE is 'string%' , it is faster. The problem is when % is at the beginning of the string. Is there some sort of...
asked by 13.08.2014 / 03:33
3
answers

How to sort by Like relevancy?

I am doing an autocomplete that makes a request to a url, which in turn queries the database. This query is done with LIKE . I use %$termo% to be able to query, however I would like to sort the result according to the relevance o...
asked by 17.05.2017 / 16:17
2
answers

What is undescore for "_" in MYSQL LIKE?

In a previous question regarding LIKE in MYSQL , Should I avoid injecting"% "into a query where I used" LIKE "? , a question arose of _ (undescore) can be used in the LIKE operator. I've used the % a lot, bu...
asked by 17.09.2015 / 19:14
1
answer

select like in more than 3 million rows

I have a Maxmind table, with more than 3 million cities. I created the index for a simple select and it is performing satisfactorily. The problem is that I am using an autocomplete and for this my select uses like , but always returns...
asked by 20.04.2015 / 20:17
1
answer

Error with sql Like

How do I extract all fields beginning with '1.' from the database? In my statement I used LIKE but it did not have any return, but if I remove the point it already returns something, but it returns fields that I do not want, eg 10.1; What's wron...
asked by 02.12.2015 / 11:02
2
answers

T-SQL with like sensitive to case

Is it possible to query in SQL Server 2008 with like sensitive? Actually, I'm looking at a column with a list of acronyms, which represent system flags, which are case sensitive. The question is not about the performance of this search, since...
asked by 30.01.2014 / 13:46
1
answer

What real difference between the '=' and LIKE?

By doing another test (rs) on a database that I have in MySQL, I realized that: SELECT * From client WHERE uuid = '1kvsg4oracxq' returned the same result as: SELECT * From client WHERE uuid LIKE '1kvsg4oracxq' What exactly is the diffe...
asked by 12.06.2017 / 18:15
1
answer

Should I avoid injecting "%" into a query where I use "LIKE"?

I have a page where I consult the user through the name. The query aims to use LIKE to capture the user name from the first letter onwards. So I do the query this way SELECT * FROM usuarios WHERE nome LIKE 'Gu%' I'm using Larav...
asked by 17.09.2015 / 17:07
1
answer

DataSet does not recognize LIKE and search parameters

Good evening. I have a table in the MySql database and I am using a DataSet to handle it in my Windows Form project. The problem is that when I try to use a query with LIKE, it does not recognize the parameter I'm requesting. SELECT nome FROM...
asked by 30.05.2017 / 01:02