Questions tagged as 'operador-like'

Tagged questions
1
answer

What is the best practice for making a large table query?

I have a system composed of several tables. One of the tables is called Publications and contains 15 varied fields, 3 of them being the main ones of my doubt: 1. titulo - varchar(100) 2. subtitulo - varchar(200) 3. texto - text In...
asked by 29.08.2017 / 19:51
1
answer

LIKE query in related table

I have a query that does the search for TECHNICAL CALLS and in this research I make some JOINS to bring related information. I need LIKE to also work for the CLIENT name (which is in another table) The query I have is this: SELECT *,...
asked by 27.03.2014 / 20:43
1
answer

Inner Join with like, Mysql, and Datatable

Personally, I have a problem at the time of searching a field in the datatable, I have a taxpayer table, this is linked to taxpayers_param, taxpayers_end and taxpayers_tel. I'm trying to do a search using like and inner join, until then the sear...
asked by 07.08.2018 / 17:48
2
answers

Search only a random part inside a code with select in mysql

The problem is as follows, I have the concatenated code, I need to see this concatenated code if part of it is in the table, ie by putting field 1 and field 2 > with PHP, before searching the table, a variable brings me this preprogrammed, I...
asked by 09.07.2015 / 01:04
2
answers

Second Like does not work SQLIte

Well, when doing a query: Cursor cursor = database.rawQuery("SELECT nome, imagem, descricao FROM Marcas WHERE descricao LIKE ? OR nome LIKE ?", new String[]{name}); Only returns results through the description, ie the second like is...
asked by 10.04.2017 / 17:02
0
answers

How to search for similar words (misspellings) in MYSQL

I'm building a search system using Mysql and PHP, with a form in the _GET method. I wanted to put together a system that if the person types the wrong one, the site can "correct" the word, or suggest the correct word. The only way I though...
asked by 14.09.2018 / 22:30
1
answer

MongoDB queries using like and disregarding accents and case

I would like to know how I can perform queries in mongodb when I can refer to any position in the string (Like) but it would also be necessary to disregard special characters such as accents. I was able to disregard the special characters in...
asked by 30.09.2017 / 21:09
1
answer

Doubt to count records in a MySQL database query

In a MySQL database, I have two columns of type varchar that brings me records in this format: ["165","184","192","209","242"] One more example: Each number in double quotation marks is a record, that is, it is the ID of some stude...
asked by 25.09.2018 / 20:42