Tag: string

Order by match on multiple columns (and with mutiple conditions)

postgresql python sql sql-order-by string

My issue is I want to order by match on a specific search string. This is the logic: If the title, author or isbn are the same as search, show these books first If the title, author or isbn are the like %search, show these books second If the title, author or isbn are the like search%, show these books

From string, extract a word starting with a keyword (SQL or any other methods?)

mariadb mysql sql string

Let’s say I have a string of random characters, and I want to extract only the string that starts after a specific keyword (including the keyword). How could I do so using MySQL or MariaDB? ………….. String example: axdsSSFddlwie ====> SSFddlwie aldfklafnlanaSSFiiie ====> SSFi…

How to get the part of a string after the last occurrence of certain character?

postgresql split sql string substring

I would like to have the substring after the last occurrence of a certin character. Now I found here how to get the first, second or so parts, but I need only the last part. The input data is a list of file directories: Unfortunately this is the data I have to work it, otherwise I could list it using

Extract string between two characters in a string

azure-sql-database sql sql-server string tsql

I have a set of strings that has datetime values and I would like to extract them. I am not sure if this is even possible using T-SQL. Expected Results: Answer For this dataset, string functions should do it: The idea is to count backwards from the end of the string, and capture the 14 characters that preced …

How to make IN on values from cell?

csv join sql sqlite string

I have table which contains list of data ceparated by coma eg I am trying to left joint it with IN clause, but without success Answer One option uses string functions:

How to extract text between two words in Oracle

oracle regex select sql string

This is the source string: random foobar “name” : “Jack Ryan”, other random stuff In Oracle query, how do I extract Jack Ryan from it? I guess I am looking for whatever is between “name” : ” and “,…

Update field with a shorter string

mysql sql sql-update string wordpress

I need to modify the LENGTH of text in field in db mysql. I’ve attribute_name that I need to have with max LENGTH 28 characters. WordPress and woocommerce limit this field to 28 characters. Right now my website is down because some taxonomies are too long. There is a way to “cut” all attribu…

How to return the difference between 2 strings using Oracle SQL only

difference oracle oracle-fusion-apps sql string

I have 2 strings for example: ‘Source:Siebel; Name:Mary Jane; Gender:F; Age:24; N;’ ‘Source:Siebel; Name:Marie; Gender:F; Age:24; N;’ The result I need is: Name:Mary Jane; Name:Marie; Most likely I need to reverse below code from Oracle Function to return similarity between strings as …