Most voted "operator-like" questions
25 questions
Sort by count of
-
14
votes3
answers3192
viewsWhat is the difference between Full Text Search and LIKE?
I’ve heard a lot about the term Full Text Search (FTS) lately, and I’ve been told that I should use this instead of drafting the queries with LIKE. But how to use the Full Text Search? What are the…
-
8
votes2
answers654
viewsPerformance of query LIKE in Mysql
Is there any way to increase the performance of a query with LIKE '%string%' in Mysql? I know that if the LIKE for 'string%', is faster. The problem is when the % is at the beginning of the string.…
-
8
votes3
answers799
viewsHow to sort by the relevance of Like?
I’m making an autocomplete that makes a request to a url, which in turn queries in the database. This consultation is made with the LIKE. I use %$termo% to be able to consult, but I would like to…
-
6
votes1
answer402
viewsselect like over 3 million lines
I have a Maxmind table, with more than 3 million cities. I created the indexes for a simple select and is at satisfactory performance. The problem is that I am using an autocomplete and for that my…
-
6
votes2
answers558
viewsWhat is the undescore "_" in the MYSQL LIKE?
In a previous question regarding LIKE in the MYSQL, I should avoid the injection of "%" in a query where I use "LIKE"?, a question has arisen regarding the _ (undescore) can be used on the operator…
-
5
votes1
answer92
viewsError with Like do sql
How do I extract all fields starting with '1. ' from the BD? In my instruction I used the LIKE but had no return, but to remove the point already returns something, but returns fields I do not want,…
-
4
votes2
answers2443
viewsT-SQL with case sensitive like
Is it possible to make a query in SQL Server 2008 with sensitive like? Actually, I’m looking in a column with a list of acronyms, which represent system flags, which differentiate uppercase and…
-
3
votes1
answer130
viewsShould I avoid injecting "%" in a query where I use "LIKE"?
I have a page where I consult the user through the name. The query aims at the use of LIKE to capture the user name from the first letter onwards. So I consult this way SELECT * FROM usuarios WHERE…
-
3
votes1
answer53
viewsDataset does not recognize LIKE and search parameters
Good night.I have a table in the Mysql database and 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…
-
3
votes1
answer1722
viewsWhat is the real difference between the operator '=' and LIKE?
Doing another test (rs) in a database I have in Mysql, I realized that: SELECT * From client WHERE uuid = '1kvsg4oracxq' returned the same result as: SELECT * From client WHERE uuid LIKE…
-
3
votes1
answer52
viewsHow to make a LIKE IN equivalent to PROCV
I have the following question (below is just an example, because I can not send the true info) I want to make a where where I find the name of the social reason by the fancy name of the…
-
1
votes1
answer412
viewsLIKE query in related table
I have a query that searches for TECHNICAL CALLS and in this research I do some JOINS to bring related information. I need the LIKE to also work for the CLIENT name (which is in another table) The…
-
1
votes2
answers67
viewsSearch only a random part within a select mysql code
The problem is this, I have the code concatenated, I need to see this code concatenated if part of it is in the table, ie when joining field 1 and field 2 with PHP, before searching in the table, a…
-
1
votes3
answers260
viewsProblem in PHP+Mysql query using LIKE
Good afternoon guys, recently in one of my projects a problem arose and I hope you can help me. To better understand the site is a site of consultations in the area of health, as clinics,…
-
1
votes1
answer92
viewsWhat is the best practice for consulting in large tables?
I have a system composed of several tables.One of the tables is called Publications and contains 15 varied fields, 3 of which are the main ones of my doubt: 1. titulo - varchar(100) 2. subtitulo -…
-
1
votes1
answer364
viewsInner Join with like, Mysql and Datatable
Speak people, I have a problem at the time of searching a field in the datatable, i have a table of contributors, this is linked with the contributors_param, contributors_end and contributors_tel.…
-
0
votes2
answers197
viewsAccording to Like does not work Sqlite
Good, when doing a query: Cursor cursor = database.rawQuery("SELECT nome, imagem, descricao FROM Marcas WHERE descricao LIKE ? OR nome LIKE ?", new String[]{name}); It only returns results through…
-
0
votes0
answers113
viewsHow to search for similar words (spelling errors) in MYSQL
I am building a search system using Mysql and PHP, with a fomulário in the _GET method. I wanted to set up a system that if the person type wrong, the site can "correct" the word, or suggest the…
-
0
votes1
answer771
viewsMongodb queries using like and disregarding accents and case
I would like to know how I can make queries in mongodb when I can consult in any position of the string (Like), but it would also be necessary to disregard special characters such as accents. I was…
-
0
votes1
answer49
viewsLIKE with strange behavior in MYSQL
I have the following query SELECT p.nome_completo, p.id_pessoa, curr.link_video, prof.nome as nome_profissao, fav.id_favorito as fav_id FROM candidato as cand INNER JOIN pessoa as p on (p.id_pessoa…
-
0
votes0
answers411
viewsQuery with like and or with PHP variable
I have a form with two inputs one type text and one type date. I am trying to make a query where the result should be filtered either by name field or by birth date field or by two together. It…
-
-1
votes2
answers51
viewsHow to check if a character set exists in the table column?
I have the following table: |id|nome | |1 |Lucas Santos da Silva| |2 |Igor Julião Gonçalves| |3 |Mário Marques Silva | |4 |David Silva | How could I catch all the people who have Silva in the name?…
-
-1
votes3
answers64
viewsHow to filter only numbers with 'Like' SQL
I have a table in which the field mainUnitId has the following data: Ad23 Ad7 Ad11 Ad9 Adv1 Adv14 Adv21 I need to bring in the search only those who have Ad + numbers after My code: SELECT * FROM…
-
-2
votes1
answer71
viewsDoubt to count records in a Mysql database query
In a Mysql database, I have two varchar columns that bring me records in this format: ["165","184","192","209","242"] One more example: Each number in double quotes is a record, IE, is the ID of…
-
-2
votes1
answer102
viewsLIKE for timestampz sequelize
I am trying to filter the activities by date but the field is timestampz. The bank I am using is the postgres { "name": "SequelizeDatabaseError", "parent": { "name": "error", "length": 220,…
javascript node.js query sequelize-js operator-likeasked 4 years, 9 months ago Gabriel Guizardi Cardoso 1