You need to write a few mysql commands.
There is a table filled with texts with a length of about 600 characters.There is a list of keys.The task is the following:
It is necessary to break the table according to the keywords and draw the phrase where the keyword is located.For example:
Consulta precio con iva y transporte preciosa composición de salón de 229 cm.It has a low TV, a vitrina for colgar, a bodeguero and a estante.available in two colors: cambria or andersen pino.The characteristics are: tablero melamínico de alta calidad.Herrajes metálicos.Include LED lights for la vitrina and el bodeguero.The color is andersen pino.and cambrian.format of the product: mueble en format kit.The product reaches completely desmontado a house.We are distributors, not montamos.The format kit is easy.el mueble include everything necessary for its installation: manual con instruccione
The TRANSPORTE key must draw a trace: Consulta price con iva y transporte preciosa composición de salón de 229 cm
If there is a long phrase then we will count to the left of the key and cut the text.
Client's review of cooperation with freelancer
You need to write a few mysql commands.Fast and quality. I recommend cooperation!
Freelancer's review of cooperation with Dmitry Svirin
You need to write a few mysql commands.Thanks Dmitry for the order, everything went well, paid quickly, responds quite quickly. Thanks again!
![]()
-
база на чем?
-
Добрый вечер,
Можете уточнить: необходимо использовать исключительно SQL-запросы или дополнительно реально подключить бекенд?
Вытащить записи реально и SQL-запросами, а вот для разбивки на предложения нужно подключать какой-то скрипт обработки.
-
Current freelance projects in the category Databases & SQL
It is necessary to check the scripts and update the data in the Postgres database.It is necessary to correct the SQL scripts for the Postgres database. It is required to check the scripts and update data from external Excel tables and between two Postgres databases (different servers). Scripts will be run through AnyDesk using Navicat. List of data for… Databases & SQL ∙ 1 day 11 hours back ∙ 18 proposals |
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 2 days 4 hours back ∙ 9 proposals |
Basketball Coaching Education Platform + Custom CMSBasketball Coaching Education Platform + Custom CMSProject Overview We are looking for an experienced web development team or full-stack developer to build a modern basketball coaching education platform. The website will provide basketball coaches with access to educational… Databases & SQL, Web Programming ∙ 2 days 22 hours back ∙ 89 proposals |
Integration of Viber in 8.3
223 USD
Need Viber integration into own CRM (1C 8.3)About the Company The company "Domofon System" is engaged in the installation and maintenance of intercom systems. Base of over 40,000 subscribers. We work on our own customized system based on 1C 8.3. We are looking for a specialist… Databases & SQL, Bot Development ∙ 3 days 1 hour back ∙ 16 proposals |
Refinement of 1C UT 11 for Zebra TSD (RDP): different sound signals when scanning
22 USD
Configuration: 1C UT 11 Address warehouse Zebra TC26 TSD Work via RDP Product scanning is performed in receiving, placement, picking documents, and other warehouse operations. Current problem: Warehouse workers operate through the Zebra TSD. When scanning, they do not always… C#, Databases & SQL ∙ 4 days 23 hours back ∙ 6 proposals |