You need to write a few mysql commands.
8 USDThere 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.
Добрый день,
Есть таблица заполненная текстами, длиной около 600 символов.
Есть список с ключами.
задача следующая:
Необходимо разбить таблицу согласно ключевым словам и вытащить фразу где находится данное ключевое слово.
К примеру:
Consulta precio con iva y transporte preciosa composición de salón de 229 cm. tiene un bajo tv, una vitrina para colgar, un bodeguero y un estante. disponible en dos colores: cambria o andersen pino. características: tablero melamínico de alta calidad. herrajes metálicos. incluye luces led para la vitrina y el bodeguero. color: andersen pino. cambrian. formato del producto: mueble en formato kit. el producto llega completamente desmontado a casa. somos distribuidores,no montamos. el formato kit facilita . el mueble incluye todo lo necesario para su instalación: manual con instruccione
Ключ TRANSPORTE, должно вытащить след: Consulta precio con iva y transporte preciosa composición de salón de 229 cm
Если будет длинная фраза тогда будем считать влево от ключа и отрежем текс.
Client's feedback on cooperation with freelancer
You need to write a few mysql commands.Fast and quality. I recommend cooperation!
Freelancer's feedback on 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!
Profile deleted | Safe
-
1484 55 2 1 Hello to you,
Requires clarification:
If a key word is repeatedly
If two keywords in a row...
Здравствуйте,
нужны уточнения:
если в тексте несколько раз ключевое слово встречается
если 2 ключевых слова подряд...
-
100 Good day .
Ready to perform the task. The cost and deadlines can be discussed after reviewing the full volume of work.
Добрый день.
Готов выполнить задание. Стоимость и сроки можем обсудить после просмотре полного объема работ.
-
база на чем?
-
Добрый вечер,
Можете уточнить: необходимо использовать исключительно SQL-запросы или дополнительно реально подключить бекенд?
Вытащить записи реально и SQL-запросами, а вот для разбивки на предложения нужно подключать какой-то скрипт обработки.
-
Current freelance projects in the category Databases
Web applicationIt is necessary to expand the functionality of the existing web application (TypeScript, React, and Next.js) by adding a fuzzy search module. The databases are large, Elasticsearch or Manticore Search should be implemented for data indexing. Databases, Web programming ∙ 2 proposals |
Loading products into an online store in Wordpress
54 USD
Loading products - wigs and accessories. Variative - 273 products, several photos for each product, + color variations. Non-variative 33 products. Option 1: upload products from Excel document to my Wordpress online store www.wigs.lv, 3 languages. Sample document attached.… Databases, Data parsing ∙ 3 proposals |
Develop a mobile application. Backend + Frontend Android/iOSA design has been developed. An application-catalog with user registration, filters, search, the ability to add to saved and comparison. cracking of requests from the state website (most likely parsing), a feed of recommendations based on interests, push notifications. A… Databases, Hybrid mobile apps ∙ 14 proposals |
Development of database architecture
501 USD
Database Architecture Development Description: We are looking for an experienced database architect to conduct an analysis of our current database architecture and develop recommendations for its improvement. Our goal is to optimize performance, ensure scalability, and enhance… Databases ∙ 5 proposals |
Data table formatting and RFM analysis1. The CRM table of all customer orders has been exported. It needs to be formatted in such a way that it becomes convenient for reading and working. The following columns should be included: customer (full name), phone number, total number of orders, date of the last order,… Databases, Data processing ∙ 6 proposals |