Project

General

Profile

Actions
Copy link

Bug #108

closed

[ADMIN/USER] SQL

Added by Deca Park about 1 year ago. Updated 8 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Deca Park
Start date:
08/31/2023
Due date:
% Done:

0%

Estimated time:
Spent time:
1.00 h

Description

[ADMIN / USER] all SQL

1.product_code / qna_code (don't use LIKE on _code PK column)

  • Change LIKE with = 

2.order_no / product_name_list / mall_name_list / product_name / product_code
   username / id
   MallRecommend > title / content

  • Remove UPPER()

3.order_no

  • Change LIKE with = 
Actions
Copy link
 #1

Updated by Toby Pham about 1 year ago

  • Status changed from New to Resolved
  • Assignee changed from Toby Pham to Deca Park
Actions
Copy link
 #2

Updated by Deca Park about 1 year ago

  • Description updated (diff)
Actions
Copy link
 #3

Updated by Deca Park 8 months ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF