In my Postgres 13 DB I want to update a column mother_tongues_id in my table based on name columns. Names are like "Le Minh Thien" and I want to check if those contain words like 'le' or 'lee' then set…
I have these tables: Project id name version 1 Swam 0.0.1 2 Dinali 0.0.1 3 Dinali 0.0.2 4 BigR 0.0.3 5 Kale 0.0.1 6 Kale 0.0.2 Person id name 1 Jake 2 Skye 3 Kieth 4 Jim 5 Eliz 6…
I have a table cities with records like: Name Value id 62 name Alberta There are many more but the format is the same. I have an API in Node.js in which I receive a city name. Now, the city…
I wrote sql select array_agg(id) as ids from fff group by a_c_id, a_c_dttm, a_c_code having COUNT(*)>1 which returns results {5,9} {8,12,13} {6,10} {7,11} How to exclude max value in each row for getting this result? {5} {8,12} {6} {7} the…
I have the following query: WITH matching_data as ( select * from consultants_matching_data_for_project(6001) ) select id, matching_data.city_matching from consultant_profiles LEFT OUTER JOIN matching_data on matching_data.consultant_profile_id = consultant_profiles.id; Is there any other way to join with matching_data result without using a…
I have the following SQL statement. It selects the visit count (vc) for a particular date (vd) SELECT count(vid) vc, date(visitwhen) vd FROM book_visit where date(visitwhen) >=date_sub(now(), interval 14 day) group by vd order by vd desc This selects a…
I am trying to update my table column but I keep getting one value for all the rows, what am I doing wrong? <?php $count = 1; while ( $count <= 30) { $fmle_img = "_src/img/profile/female/u$count.png"; $db->query("UPDATE users SET image=:image…
I have two tables that I am trying to join and display the count of transactions by year grouped by user_name. The data is from two separate tables: users and transactions. I need the output to have four total columns:…
I have data like below Amount currency Investors 250 USD Coinvest I 0 GBP Coinvest I 860 USD Paralell 0 GBP Paralell 121 USD PSLO 5 NULL PSLO I need output like below Amount currency Investors 250 GBP Coinvest I…
I have sample data that looks like the following: fname lname x abc jkn test test gth yg-txs gb@y Need to write simple query to remove all special character and spaces, concat fname and lname put it in fullname column,…