I am using spring-data-jpa here is my query @Query(value = "select ea.* from employee ea where ids in (?1) and (?2 is null or country=?2) ", nativeQuery = true) Page<Employee> findByds(List<UUID> ids,String country ,Pageable pageable ); I want to get…
When the data having same date( even the micro second ) like below table. If I There is a table below Create_At User_ID Balance 2022-09-29 09h:09:01.761335 4 200300 2022-09-30 12h:09:47.405520 6 58111 2022-09-30 12h:09:47.405520 6 53861 2022-09-29 11h:09:46.276274 6 79011…
How to correct below misspelled data in column market: market SocialMediaAdvertising SocialInvesting FinancialExchanges CloudMagement VentureCapital I don't know what syntax to write. But output should be as below: market Social Media Advertising Social Investing Financial Exchanges Cloud Magement Venture Capital
Products have names like Product one white Adidas Other product black Hill sheet Nice T-shirt blue Brower company How to get starting part of product name before first uppercase word starting from second word and up to first uppercase word…
I have 3 tables; idmaster data1 data2 idmaster has every id. I need to count how many times each id exists in both data1 and data2 and output them seperate. id comes from idmaster. Ideally would like to have all…
I have a table "blobs" with a column "metadata" in jsonb data-type, Example: { "total_count": 2, "items": [ { "name": "somename", "metadata": { "metas": [ { "id": "11258", "score": 6.1, "status": "active", "published_at": "2019-04-20T00:29:00", "nvd_modified_at": "2022-04-06T18:07:00" }, { "id": "9251",…
I have a complex json stored in a varchar(max) column. I have an array of strings in the json. myArray: ['one', 'two', 'three', 'four'] I am running the following update query to delete property two from the array above using…
I am trying to put a regexp constraint on a field "StaffAdress" such that it should only end with " street". This is my attempt, but it still doesn't seem to be valid. I tried regexp '.*street$' and regexp 'street$'…
So i'm trying to make a old project work again but when i put back my tables to the new database i'm having this issue ERROR 1005 (HY000) at line 777: Can't create table ****.#sql-3f2_45 (errno: 150 "Foreign key constraint…
I have a Codeigniter website where I am displaying some values using a foreach(). I am trying to ignore specific values from database. I wrote the following code: $res="select * from paymentform order by id desc limit 1000"; $query =…